<?php
//2015404233吴长猷

require_once 'db_conn.php';

$id=isset($_GET['id'])?$_GET["id"]:0;

if (empty($_POST))
{
    
    $sql="select * from tb_emp where e_id=$id";
    $result=$db->query($sql);

    $row=$result->fetch_assoc();
    require 'edit_html.php';
}
 else {
 $e_name=$_POST['e_name'];
 $e_dept=$_POST['e_dept'];
 $e_img=$_POST['e_img'];
 $date_of_birth=$_POST['date_of_birth'];
 $date_of_entry=$_POST['date_of_entry'];
    
    $sql="update tb_emp set e_name='$e_name',e_dept='$e_dept',e_img='$e_img',date_of_birth='$date_of_birth',date_of_entry='$date_of_entry' where e_id=$id";

    $result=$db->query($sql); 
    if ($result)
       {
           echo "<script language='javascript' type='text/javascript'>";
           echo "alert('修改成功');";
           echo "window.location.href='index.php'";
           echo "</script>";
       }
    else 
       {
           echo "<script language='javascript' type='text/javascript'>";
           echo "alert('修改失败！');";
           echo "window.location.href='index.php'";
           echo "</script>";
          
       }
}
